/**
 *
 */
package tec.data.persistence.oracle;

import java.sql.SQLException;

public class Main {
	/**
	 * @param args
	 * @throws SQLException
	 */
	public static void main(String[] args) throws SQLException {
		/*
		String sql = "insert into evtm_event(event_id, description, asso_date) " + 
				"values(5, \'XXX\', \'23-sep-2010\')";
				
		SQLExecuter ex = new SQLExecuter();
		ex.connect();
		ex.execute(sql);
		*/
		BasicConnectionParameter bp = new BasicConnectionParameter();
		bp.setHost("localhost");
		bp.setPort(1521);
		bp.setSid("orcl");
		bp.setUserName("joe");
		bp.setPassword("741114");
		
		TNSConnectionParameter tp = new TNSConnectionParameter();
		tp.setTNSName("orcl");
		tp.setUserName("joe");
		tp.setPassword("741114");
		
		System.out.println(new ThinConnectionHelper().getConnection(bp));
		System.out.println(new ThinConnectionHelper().getJDBCConnection(bp));
		System.out.println(new OCIConnectionHelper().getConnection(bp));
		System.out.println(new OCIConnectionHelper().getConnection(tp));
		System.out.println(new OCIConnectionHelper().getJDBCConnection(tp));		
	}
}
